<html>

<head>
  <title></title>
</head>

<body>

<?php

include "kernel.php";
include "adw_functions.php";

//red fuel bunker
$r = mysql_query("select count(*) as c from killboard where MissionID>1696 and Team1>1 and Team2>1 and killedid=1144");
$res = mysql_fetch_assoc($r);
echo "Red fuel bunkers destroyed: ".$res[c].", Total ".(30*$res[c])." tonns.\r\n<bR>";

//blue fuel bunker
$r = mysql_query("select count(*) as c from killboard where MissionID>1696 and Team1>1 and Team2>1 and killedid=1106");
$res = mysql_fetch_assoc($r);
echo "Blue fuel bunkers destroyed: ".$res[c].", Total ".(30*$res[c])." tonns.\r\n<bR>";


//red rkit
$r = mysql_query("select count(*) as c from killboard where MissionID>1696 and Team1>1 and Team2>1 and killedid=1190");
$res = mysql_fetch_assoc($r);
echo "Red rkit bunkers destroyed: ".$res[c].", Total ".(30*$res[c])." tonns.\r\n<bR>";

//blue rkit
$r = mysql_query("select count(*) as c from killboard where MissionID>1696 and Team1>1 and Team2>1 and killedid=1137");
$res = mysql_fetch_assoc($r);
echo "Blue rkit bunkers destroyed: ".$res[c].", Total ".(30*$res[c])." tonns.\r\n<bR>";


//red ammo
$r = mysql_query("select count(*) as c from killboard where MissionID>1696 and Team1>1 and Team2>1 and killedid=1157");
$res = mysql_fetch_assoc($r);
echo "Red ammo bunkers destroyed: ".$res[c].", Total ".(30*$res[c])." tonns.\r\n<bR>";

//blue ammo
$r = mysql_query("select count(*) as c from killboard where MissionID>1696 and Team1>1 and Team2>1 and killedid=1142");
$res = mysql_fetch_assoc($r);
echo "Blue ammo bunkers destroyed: ".$res[c].", Total ".(30*$res[c])." tonns.\r\n<bR>";
?>

</body>

</html>